#!/bin/bash

tables=( "calendar" "class_studying_student_count" "course_table_upload_detail" "customer" "customer_appeal" "customer_clue" "customer_relationship" "employee" "itcast_clazz" "itcast_school" "itcast_subject" "scrm_department" "student_leave_apply" "tbh_class_time_table" "tbh_student_signin_record" "web_chat_ems_2019_07" "web_chat_text_ems_2019_07" )


for table in ${tables[@]};
do
sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" --connect 'jdbc:mysql://192.168.88.80:3306/online_teach?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' --username root --password 123456 --query "select * from ${table} where 1=1 and  \$CONDITIONS" --hcatalog-database zxjy_ods --hcatalog-table ${table} -m 1
echo "================================================================="

done






